﻿CREATE TABLE [dbo].[Jobs]
(
[JobID] [varchar] (50) NOT NULL,
[RunID] [varchar] (50) NULL,
[ComponentID] [varchar] (50) NULL,
[ComponentTypeName] [varchar] (500) NULL,
[Cancelled] [bit] NULL,
[Dependency] [varchar] (4000) NULL,
[HasError] [bit] NULL,
[IsFirstJob] [bit] NULL,
[IsLastJob] [bit] NULL,
[JobInstructionTypeName] [varchar] (500) NULL,
[JobOutputTypeName] [varchar] (500) NULL,
[JobInstructionID] [int] NULL,
[JobOutputID] [int] NULL,
[Priority] [int] NULL,
[ReceiveTime] [datetime] NULL,
[SubmissionTime] [datetime] NULL,
[StartTime] [datetime] NULL,
[FinishTime] [datetime] NULL
) ON [PRIMARY]


